package com.dk.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dk.pojo.TbCars;
import com.dk.vo.TbCarsVO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface TbCarsMapper extends BaseMapper<TbCars> {


    @Select("select tb_cars.id,tb_cars.`name`,brand_id,price,starttime,picture,auction_not,cids,mileage,discharge,registered_date,license_plate,color,expiration_time,number,cid,prices,evaluated_price,earnest_money,start_times,end_time,auction,bid_increment from\n" +
            "tb_cars inner JOIN dic_record inner JOIN tb_auction on tb_cars.id  = dic_record.cids=tb_auction.cid where tb_cars.id = #{id}")
    TbCarsVO selectAll(Long id);
}
